<?xml version="1.0" encoding="utf-8"?>
<Content xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:blueonionsoftware-com:bloget:runtime:data">
  <text>This example sql shows the filenames for the images in a particular study:

&lt;pre&gt;
select convert(binary(4), ordinal), patient_name from osr_location, dosr_object, dosr_study
where osr_location.object_ref = dosr_object.object_ref
and dosr_object.study_ref = dosr_study.study_ref
and dosr_object.number_of_frames is not null
and dosr_study.patient_name like '%ultrasound-rle-palette-single%'

0x00008A04	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A50	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A54	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A56	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A64	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A66	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A68	^ULTRASOUND-RLE-PALETTE-SINGLE
0x00008A6A	^ULTRASOUND-RLE-PALETTE-SINGLE
&lt;/pre&gt;

In this example, there are 8 images for that patient_name, and the hex value is the corresponding filename in the server's cache.  So, 0x00008A6A becomes //six-feet-under/cache/00008A6A.dcm.

</text>
  <last_update>2007-10-04T00:52:30.1310806Z</last_update>
  <source_title />
  <source_link />
  <comments>
    <comment>
      <id>0b8e5a8e-488f-4372-af54-55b381c5cd8a</id>
      <title />
      <date>2005-02-22T09:02:31</date>
      <author>amarks</author>
      <email />
      <text>You can achieve the same result by using the DicomFilesBrowser utility available in:

\Intern\DicomFilesBrowser

This utility may have to be run at the server though, I'm not sure.

Also it is already installed on every server.
</text>
    </comment>
    <comment>
      <id>be87995d-b694-42cf-a80b-39c5f530bbf0</id>
      <title />
      <date>2005-03-10T14:03:01</date>
      <author>Sunanda</author>
      <email />
      <text>I have made some changes to "DICOMFilesBrowser" utility recently (Actually the binary name is DICOMFiles.exe), so that it can be actually run from a Workstation. 

Also, the other enhancements that I made to this utility include "Wild Character search" on the Patient ID and Patient Name.

You can copy the image/sr files to your local machine and also view using DICOMFileReader directly (if you have DICOMFileReader in the path)

For those of you who do the nightly build using David Ei's nightly build script, DICOMFiles.exe is automatically built every night,so you should be able to run the "DICOMFiles.exe" from your O:\SearchablePathForDLLS\Release\DICOMFiles.exe.



</text>
    </comment>
  </comments>
  <references />
  <attachments />
</Content>